/*
 * @Author: Klein
 * @Date: 2021-06-17 11:33:53
 * @Description: file content
 */

const { DataTypes } = require("sequelize");
const sequelize = require("../lib/connection");

const Projects = sequelize.define(
  "basic_project",
  {
    project_name: DataTypes.STRING,
    project_customer: DataTypes.STRING(11),
    project_number: DataTypes.STRING,
    project_leader_id: DataTypes.INTEGER(32),
    projectStatus: {
      type: DataTypes.INTEGER(1),
      // autoIncrement: true,
      field: "project_status",
    },
    create_time: DataTypes.DATEONLY,
    update_time: DataTypes.DATEONLY,
  },
  {
    freezeTableName: true,
    timestamps: false,
  }
);

module.exports = Projects;
